You will receive alliance offers when other Great Powers perceive you to be very strong, or when they are desperate for help. It’s almost always a good idea to accept alliance offers, especially early in the game. 

The only time you should decline is if you will be dragged into a war that is ongoing between your new ally and their enemies. Such consequences, if any, will be listed beneath the offer.